# coding: utf-8
from application import db
from common.models.user import User

class ProjectGantt(db.Model):
    __tablename__ = 'project_gantt'

    id = db.Column(db.Integer, primary_key=True)
    text = db.Column(db.String(255, 'utf8mb4_0900_ai_ci'))
    userid = db.Column(db.Integer,db.ForeignKey('user.id'))
    username = db.relationship('User', foreign_keys=userid)
    bz = db.Column(db.String(255, 'utf8mb4_0900_ai_ci'))

    start_date=db.Column(db.DateTime)
    duration=db.Column(db.Integer)
    parent = db.Column(db.Integer)
    progress=db.Column(db.Float)
    color=db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    status=db.Column(db.Integer)
    row_height = db.Column(db.Integer)
    bar_height = db.Column(db.Integer)
    open=db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))

    updated_time = db.Column(db.DateTime)
    created_time = db.Column(db.DateTime)


